https://thatim.com/what-makes-stored-procedures-faster-than-sending-a-transact-sql-statement-to-sql-server
What makes stored procedures faster than sending a Transact SQL statement to SQL Server?